Amazon Cleaned Sales Data

Dataset statistics

Number of variables	21
Number of observations	65241
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	10.5 MiB
Average record size in memory	168.0 B

Variable types

Numeric	14
Categorical	7

Alerts

`DateKey` has a high cardinality: 558 distinct values	High cardinality
`Invoice Date` has a high cardinality: 558 distinct values	High cardinality
`Item Number` has a high cardinality: 983 distinct values	High cardinality
`Item` has a high cardinality: 650 distinct values	High cardinality
`Promised Delivery Date` has a high cardinality: 590 distinct values	High cardinality
`Discount Amount` is highly overall correlated with `Sales Amount` and 3 other fields	High correlation
`List Price` is highly overall correlated with `Sales Price` and 1 other fields	High correlation
`Sales Amount` is highly overall correlated with `Discount Amount` and 3 other fields	High correlation
`Sales Amount Based on List Price` is highly overall correlated with `Discount Amount` and 3 other fields	High correlation
`Sales Cost Amount` is highly overall correlated with `Discount Amount` and 3 other fields	High correlation
`Sales Margin Amount` is highly overall correlated with `Discount Amount` and 3 other fields	High correlation
`Sales Price` is highly overall correlated with `List Price` and 1 other fields	High correlation
`Sales Quantity` is highly overall correlated with `List Price` and 1 other fields	High correlation
`Item Class` is highly imbalanced (99.7%)	Imbalance
`U/M` is highly imbalanced (68.2%)	Imbalance
`Sales Cost Amount` is highly skewed (γ1 = 21.0046152)	Skewed
`Sales Quantity` is highly skewed (γ1 = 23.00067352)	Skewed
`Unnamed: 0` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`Discount Amount` has 1214 (1.9%) zeros	Zeros

Reproduction

Analysis started	2023-01-21 08:05:36.744951
Analysis finished	2023-01-21 08:06:35.162081
Duration	58.42 seconds
Software version	pandas-profiling vv3.6.2
Download configuration	config.json

Unnamed: 0
Real number (ℝ)

UNIFORM UNIQUE

Distinct	65241
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32649.053

Minimum	1
Maximum	65281
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	509.8 KiB

Quantile statistics

Minimum	1
5-th percentile	3276
Q1	16324
median	32654
Q3	48970
95-th percentile	62019
Maximum	65281
Range	65280
Interquartile range (IQR)	32646

Descriptive statistics

Standard deviation	18844.646
Coefficient of variation (CV)	0.57718813
Kurtosis	-1.2005117
Mean	32649.053
Median Absolute Deviation (MAD)	16323
Skewness	-0.00023741259
Sum	2.1300569 × 10⁹
Variance	3.5512067 × 10⁸
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
43539	1	< 0.1%
43526	1	< 0.1%
43527	1	< 0.1%
43528	1	< 0.1%
43529	1	< 0.1%
43530	1	< 0.1%
43531	1	< 0.1%
43532	1	< 0.1%
43533	1	< 0.1%
Other values (65231)	65231	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
4	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
12	1	< 0.1%

Value	Count	Frequency (%)
65281	1	< 0.1%
65280	1	< 0.1%
65279	1	< 0.1%
65278	1	< 0.1%
65277	1	< 0.1%
65276	1	< 0.1%
65275	1	< 0.1%
65274	1	< 0.1%
65273	1	< 0.1%
65272	1	< 0.1%

CustKey
Real number (ℝ)

Distinct	615
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10017703

Minimum	10000453
Maximum	10027583
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	509.8 KiB

Quantile statistics

Minimum	10000453
5-th percentile	10002506
Q1	10012715
median	10019665
Q3	10023511
95-th percentile	10026006
Maximum	10027583
Range	27130
Interquartile range (IQR)	10796

Descriptive statistics

Standard deviation	7175.8459
Coefficient of variation (CV)	0.00071631648
Kurtosis	-0.37098298
Mean	10017703
Median Absolute Deviation (MAD)	4886
Skewness	-0.77030273
Sum	6.5356497 × 10¹¹
Variance	51492764
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10025919	2760	4.2%
10019194	2752	4.2%
10012715	1431	2.2%
10012226	1389	2.1%
10025025	1143	1.8%
10023524	1042	1.6%
10020515	1010	1.5%
10017638	790	1.2%
10022456	741	1.1%
10002506	714	1.1%
Other values (605)	51469	78.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10000453	329	0.5%
10000455	19	< 0.1%
10000456	104	0.2%
10000457	19	< 0.1%
10000458	10	< 0.1%
10000460	120	0.2%
10000461	251	0.4%
10000462	3	< 0.1%
10000466	123	0.2%
10000469	162	0.2%

Value	Count	Frequency (%)
10027583	25	< 0.1%
10027575	5	< 0.1%
10027572	52	0.1%
10027560	42	0.1%
10027381	108	0.2%
10027370	234	0.4%
10027356	21	< 0.1%
10027348	14	< 0.1%
10027340	35	0.1%
10027119	175	0.3%

DateKey
Categorical

Distinct	558
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	509.8 KiB

23/06/2017	460
05/07/2019	447
27/06/2017	313
18/11/2017	313
11/01/2017	310
Other values (553)	63398

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	652410
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	14/07/2017
2nd row	17/10/2017
3rd row	27/05/2017
4th row	03/09/2017
5th row	18/06/2017

Common Values

Value	Count	Frequency (%)
23/06/2017	460	0.7%
05/07/2019	447	0.7%
27/06/2017	313	0.5%
18/11/2017	313	0.5%
11/01/2017	310	0.5%
09/07/2019	307	0.5%
30/11/2019	307	0.5%
26/06/2017	294	0.5%
08/07/2019	279	0.4%
29/04/2017	279	0.4%
Other values (548)	61932	94.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
23/06/2017	460	0.7%
05/07/2019	447	0.7%
27/06/2017	313	0.5%
18/11/2017	313	0.5%
11/01/2017	310	0.5%
09/07/2019	307	0.5%
30/11/2019	307	0.5%
26/06/2017	294	0.5%
29/04/2017	279	0.4%
08/07/2019	279	0.4%
Other values (548)	61932	94.9%

Most occurring characters

Value	Count	Frequency (%)
0	144497	22.1%
/	130482	20.0%
1	122034	18.7%
2	105577	16.2%
7	41471	6.4%
9	40766	6.2%
8	18237	2.8%
3	16726	2.6%
6	11652	1.8%
5	11348	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	521928	80.0%
Other Punctuation	130482	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	144497	27.7%
1	122034	23.4%
2	105577	20.2%
7	41471	7.9%
9	40766	7.8%
8	18237	3.5%
3	16726	3.2%
6	11652	2.2%
5	11348	2.2%
4	9620	1.8%

Other Punctuation

Value	Count	Frequency (%)
/	130482	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	652410	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	144497	22.1%
/	130482	20.0%
1	122034	18.7%
2	105577	16.2%
7	41471	6.4%
9	40766	6.2%
8	18237	2.8%
3	16726	2.6%
6	11652	1.8%
5	11348	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	652410	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	144497	22.1%
/	130482	20.0%
1	122034	18.7%
2	105577	16.2%
7	41471	6.4%
9	40766	6.2%
8	18237	2.8%
3	16726	2.6%
6	11652	1.8%
5	11348	1.7%

Discount Amount
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	17730
Distinct (%)	27.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1857.3109

Minimum	-255820.8
Maximum	343532.66
Zeros	1214
Zeros (%)	1.9%
Negative	933
Negative (%)	1.4%
Memory size	509.8 KiB

Quantile statistics

Minimum	-255820.8
5-th percentile	19.0422
Q1	246.28
median	442.2
Q3	1001.5
95-th percentile	6354.225
Maximum	343532.66
Range	599353.46
Interquartile range (IQR)	755.22

Descriptive statistics

Standard deviation	9039.5358
Coefficient of variation (CV)	4.8670019
Kurtosis	379.55115
Mean	1857.3109
Median Absolute Deviation (MAD)	234.14
Skewness	10.83909
Sum	1.2117282 × 10⁸
Variance	81713207
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1214	1.9%
24.88	103	0.2%
606.84	100	0.2%
639.82	97	0.1%
601.9033	93	0.1%
634.6133	93	0.1%
402.7	93	0.1%
918.1412	88	0.1%
169.36	87	0.1%
385.98	87	0.1%
Other values (17720)	63186	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-255820.8	1	< 0.1%
-245587.97	1	< 0.1%
-238792.73	1	< 0.1%
-231837.6	3	< 0.1%
-222564.1	3	< 0.1%
-127176	1	< 0.1%
-122088.96	1	< 0.1%
-84573.72	1	< 0.1%
-81190.77	1	< 0.1%
-53626	1	< 0.1%

Value	Count	Frequency (%)
343532.66	2	< 0.1%
339103.35	1	< 0.1%
331487.76	2	< 0.1%
327213.75	1	< 0.1%
322454.09	1	< 0.1%
210371	4	< 0.1%
202995	4	< 0.1%
191196.5532	2	< 0.1%
189333.9	1	< 0.1%
182832.8832	2	< 0.1%

Invoice Date
Categorical

Distinct	558
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	509.8 KiB

23/06/2017	460
05/07/2019	447
27/06/2017	313
18/11/2017	313
11/01/2017	310
Other values (553)	63398

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	652410
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	14/07/2017
2nd row	17/10/2017
3rd row	27/05/2017
4th row	03/09/2017
5th row	18/06/2017

Common Values

Value	Count	Frequency (%)
23/06/2017	460	0.7%
05/07/2019	447	0.7%
27/06/2017	313	0.5%
18/11/2017	313	0.5%
11/01/2017	310	0.5%
09/07/2019	307	0.5%
30/11/2019	307	0.5%
26/06/2017	294	0.5%
08/07/2019	279	0.4%
29/04/2017	279	0.4%
Other values (548)	61932	94.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
23/06/2017	460	0.7%
05/07/2019	447	0.7%
27/06/2017	313	0.5%
18/11/2017	313	0.5%
11/01/2017	310	0.5%
09/07/2019	307	0.5%
30/11/2019	307	0.5%
26/06/2017	294	0.5%
29/04/2017	279	0.4%
08/07/2019	279	0.4%
Other values (548)	61932	94.9%

Most occurring characters

Value	Count	Frequency (%)
0	144497	22.1%
/	130482	20.0%
1	122034	18.7%
2	105577	16.2%
7	41471	6.4%
9	40766	6.2%
8	18237	2.8%
3	16726	2.6%
6	11652	1.8%
5	11348	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	521928	80.0%
Other Punctuation	130482	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	144497	27.7%
1	122034	23.4%
2	105577	20.2%
7	41471	7.9%
9	40766	7.8%
8	18237	3.5%
3	16726	3.2%
6	11652	2.2%
5	11348	2.2%
4	9620	1.8%

Other Punctuation

Value	Count	Frequency (%)
/	130482	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	652410	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	144497	22.1%
/	130482	20.0%
1	122034	18.7%
2	105577	16.2%
7	41471	6.4%
9	40766	6.2%
8	18237	2.8%
3	16726	2.6%
6	11652	1.8%
5	11348	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	652410	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	144497	22.1%
/	130482	20.0%
1	122034	18.7%
2	105577	16.2%
7	41471	6.4%
9	40766	6.2%
8	18237	2.8%
3	16726	2.6%
6	11652	1.8%
5	11348	1.7%

Invoice Number
Real number (ℝ)

Distinct	24650
Distinct (%)	37.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	216292.79

Minimum	100034
Maximum	332842
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	509.8 KiB

Quantile statistics

Minimum	100034
5-th percentile	104168
Q1	117969
median	222904
Q3	314325
95-th percentile	328904
Maximum	332842
Range	232808
Interquartile range (IQR)	196356

Descriptive statistics

Standard deviation	94982.019
Coefficient of variation (CV)	0.43913632
Kurtosis	-1.8436257
Mean	216292.79
Median Absolute Deviation (MAD)	98209
Skewness	0.00055331482
Sum	1.4111158 × 10¹⁰
Variance	9.0215839 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
225396	103	0.2%
113089	101	0.2%
125396	101	0.2%
126657	101	0.2%
313089	100	0.2%
325396	100	0.2%
326657	100	0.2%
129620	97	0.1%
116099	97	0.1%
316099	94	0.1%
Other values (24640)	64247	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100034	1	< 0.1%
100080	1	< 0.1%
100093	1	< 0.1%
100094	1	< 0.1%
100130	1	< 0.1%
100132	1	< 0.1%
100204	1	< 0.1%
100222	1	< 0.1%
100229	1	< 0.1%
100230	1	< 0.1%

Value	Count	Frequency (%)
332842	1	< 0.1%
332840	3	< 0.1%
332837	14	< 0.1%
332831	3	< 0.1%
332828	3	< 0.1%
332826	1	< 0.1%
332823	3	< 0.1%
332821	6	< 0.1%
332820	1	< 0.1%
332818	1	< 0.1%

Item Class
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	509.8 KiB

P01	65225
PO1	16

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	195723
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	P01
2nd row	P01
3rd row	P01
4th row	P01
5th row	P01

Common Values

Value	Count	Frequency (%)
P01	65225	> 99.9%
PO1	16	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
p01	65225	> 99.9%
po1	16	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
P	65241	33.3%
1	65241	33.3%
0	65225	33.3%
O	16	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	130466	66.7%
Uppercase Letter	65257	33.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	65241	> 99.9%
O	16	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	65241	50.0%
0	65225	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	130466	66.7%
Latin	65257	33.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	65241	> 99.9%
O	16	< 0.1%

Common

Value	Count	Frequency (%)
1	65241	50.0%
0	65225	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	195723	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	65241	33.3%
1	65241	33.3%
0	65225	33.3%
O	16	< 0.1%

Item Number
Categorical

Distinct	983
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	509.8 KiB

17801	1610
28401	1344
27550	1182
67550	1126
20910	1050
Other values (978)	58929

Length

Max length	25
Median length	5
Mean length	5.0427185
Min length	1

Characters and Unicode

Total characters	328992
Distinct characters	38
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	70 ?
Unique (%)	0.1%

Sample

1st row	20910
2nd row	38076
3rd row	60776
4th row	20910
5th row	62550

Common Values

Value	Count	Frequency (%)
17801	1610	2.5%
28401	1344	2.1%
27550	1182	1.8%
67550	1126	1.7%
20910	1050	1.6%
11690	1045	1.6%
47801	1043	1.6%
36001	947	1.5%
38076	942	1.4%
26502	913	1.4%
Other values (973)	54039	82.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
17801	1610	2.5%
28401	1344	2.1%
27550	1182	1.8%
67550	1126	1.7%
20910	1050	1.6%
11690	1045	1.6%
47801	1043	1.6%
36001	947	1.5%
38076	942	1.4%
26502	913	1.4%
Other values (982)	54100	82.8%

Most occurring characters

Value	Count	Frequency (%)
0	53332	16.2%
6	40050	12.2%
2	38591	11.7%
3	38533	11.7%
1	31241	9.5%
5	28577	8.7%
8	26759	8.1%
7	25335	7.7%
9	24277	7.4%
4	21437	6.5%
Other values (28)	860	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	328132	99.7%
Uppercase Letter	735	0.2%
Space Separator	64	< 0.1%
Dash Punctuation	26	< 0.1%
Other Punctuation	25	< 0.1%
Lowercase Letter	7	< 0.1%
Open Punctuation	2	< 0.1%
Close Punctuation	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	259	35.2%
A	87	11.8%
R	54	7.3%
S	47	6.4%
E	37	5.0%
I	36	4.9%
Z	35	4.8%
N	34	4.6%
D	33	4.5%
T	28	3.8%
Other values (11)	85	11.6%

Decimal Number

Value	Count	Frequency (%)
0	53332	16.3%
6	40050	12.2%
2	38591	11.8%
3	38533	11.7%
1	31241	9.5%
5	28577	8.7%
8	26759	8.2%
7	25335	7.7%
9	24277	7.4%
4	21437	6.5%

Other Punctuation

Value	Count	Frequency (%)
/	23	92.0%
#	2	8.0%

Space Separator

Value	Count	Frequency (%)
	64	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	26	100.0%

Lowercase Letter

Value	Count	Frequency (%)
z	7	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	328250	99.8%
Latin	742	0.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	259	34.9%
A	87	11.7%
R	54	7.3%
S	47	6.3%
E	37	5.0%
I	36	4.9%
Z	35	4.7%
N	34	4.6%
D	33	4.4%
T	28	3.8%
Other values (12)	92	12.4%

Common

Value	Count	Frequency (%)
0	53332	16.2%
6	40050	12.2%
2	38591	11.8%
3	38533	11.7%
1	31241	9.5%
5	28577	8.7%
8	26759	8.2%
7	25335	7.7%
9	24277	7.4%
4	21437	6.5%
Other values (6)	118	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	328992	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	53332	16.2%
6	40050	12.2%
2	38591	11.7%
3	38533	11.7%
1	31241	9.5%
5	28577	8.7%
8	26759	8.1%
7	25335	7.7%
9	24277	7.4%
4	21437	6.5%
Other values (28)	860	0.3%

Item
Categorical

Distinct	650
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	509.8 KiB

Better Fancy Canned Sardines	1648
Ebony Prepared Salad	1471
Moms Sliced Turkey	1192
Imagine Popsicles	1191
Discover Manicotti	1126
Other values (645)	58613

Length

Max length	37
Median length	32
Mean length	21.722582
Min length	8

Characters and Unicode

Total characters	1417203
Distinct characters	56
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26 ?
Unique (%)	< 0.1%

Sample

1st row	Moms Sliced Turkey
2nd row	Cutting Edge Foot-Long Hot Dogs
3rd row	High Top Sweet Onion
4th row	Moms Sliced Turkey
5th row	Tell Tale Garlic

Common Values

Value	Count	Frequency (%)
Better Fancy Canned Sardines	1648	2.5%
Ebony Prepared Salad	1471	2.3%
Moms Sliced Turkey	1192	1.8%
Imagine Popsicles	1191	1.8%
Discover Manicotti	1126	1.7%
Red Spade Foot-Long Hot Dogs	1075	1.6%
High Top Dried Mushrooms	1072	1.6%
Big Time Frozen Cheese Pizza	947	1.5%
Cutting Edge Foot-Long Hot Dogs	942	1.4%
Bravo Large Canned Shrimp	941	1.4%
Other values (640)	53636	82.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
canned	6375	2.8%
ebony	5460	2.4%
cheese	5192	2.3%
better	4569	2.0%
red	4271	1.9%
top	4172	1.8%
spade	4161	1.8%
high	4137	1.8%
best	3477	1.5%
nationeel	3328	1.4%
Other values (294)	184407	80.3%

Most occurring characters

Value	Count	Frequency (%)
	164308	11.6%
e	146997	10.4%
o	92424	6.5%
a	92229	6.5%
n	74029	5.2%
i	69406	4.9%
t	68697	4.8%
r	67309	4.7%
l	59799	4.2%
s	57763	4.1%
Other values (46)	524242	37.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1013133	71.5%
Uppercase Letter	236106	16.7%
Space Separator	164308	11.6%
Dash Punctuation	2160	0.2%
Other Punctuation	748	0.1%
Decimal Number	748	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	146997	14.5%
o	92424	9.1%
a	92229	9.1%
n	74029	7.3%
i	69406	6.9%
t	68697	6.8%
r	67309	6.6%
l	59799	5.9%
s	57763	5.7%
d	40526	4.0%
Other values (16)	243954	24.1%

Uppercase Letter

Value	Count	Frequency (%)
B	31413	13.3%
C	30848	13.1%
S	26119	11.1%
T	19360	8.2%
F	16230	6.9%
M	12512	5.3%
P	11463	4.9%
L	11018	4.7%
D	10750	4.6%
E	10232	4.3%
Other values (15)	56161	23.8%

Decimal Number

Value	Count	Frequency (%)
1	579	77.4%
2	169	22.6%

Space Separator

Value	Count	Frequency (%)
	164308	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2160	100.0%

Other Punctuation

Value	Count	Frequency (%)
%	748	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1249239	88.1%
Common	167964	11.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	146997	11.8%
o	92424	7.4%
a	92229	7.4%
n	74029	5.9%
i	69406	5.6%
t	68697	5.5%
r	67309	5.4%
l	59799	4.8%
s	57763	4.6%
d	40526	3.2%
Other values (41)	480060	38.4%

Common

Value	Count	Frequency (%)
	164308	97.8%
-	2160	1.3%
%	748	0.4%
1	579	0.3%
2	169	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1417203	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	164308	11.6%
e	146997	10.4%
o	92424	6.5%
a	92229	6.5%
n	74029	5.2%
i	69406	4.9%
t	68697	4.8%
r	67309	4.7%
l	59799	4.2%
s	57763	4.1%
Other values (46)	524242	37.0%

Line Number
Real number (ℝ)

Distinct	397
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23725.043

Minimum	1000
Maximum	344000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	509.8 KiB

Quantile statistics

Minimum	1000
5-th percentile	1000
Q1	3000
median	12000
Q3	32000
95-th percentile	88000
Maximum	344000
Range	343000
Interquartile range (IQR)	29000

Descriptive statistics

Standard deviation	32669.565
Coefficient of variation (CV)	1.3770076
Kurtosis	11.146323
Mean	23725.043
Median Absolute Deviation (MAD)	11000
Skewness	2.8814917
Sum	1.5478455 × 10⁹
Variance	1.0673005 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1000	11189	17.2%
2000	3696	5.7%
3000	2763	4.2%
4000	2287	3.5%
5000	1947	3.0%
6000	1839	2.8%
9000	1614	2.5%
7000	1586	2.4%
8000	1464	2.2%
10000	1412	2.2%
Other values (387)	35444	54.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	11189	17.2%
1001	247	0.4%
1002	46	0.1%
1003	5	< 0.1%
1100	4	< 0.1%
1101	4	< 0.1%
2000	3696	5.7%
2001	158	0.2%
2002	36	0.1%
3000	2763	4.2%

Value	Count	Frequency (%)
344000	2	< 0.1%
330000	2	< 0.1%
320000	2	< 0.1%
314001	2	< 0.1%
268000	2	< 0.1%
260000	2	< 0.1%
249000	2	< 0.1%
246000	2	< 0.1%
244000	2	< 0.1%
243000	7	< 0.1%

List Price
Real number (ℝ)

Distinct	1062
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	515.01683

Minimum	0
Maximum	2760.7
Zeros	255
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	509.8 KiB

Quantile statistics

Minimum	0
5-th percentile	36.69
Q1	181.56
median	325.19
Q3	803.86
95-th percentile	1431.23
Maximum	2760.7
Range	2760.7
Interquartile range (IQR)	622.3

Descriptive statistics

Standard deviation	449.1449
Coefficient of variation (CV)	0.8720975
Kurtosis	0.011618476
Mean	515.01683
Median Absolute Deviation (MAD)	217.35
Skewness	1.0051813
Sum	33600213
Variance	201731.14
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
298	1508	2.3%
1431.23	1426	2.2%
966.44	1192	1.8%
1275.1	1126	1.7%
192.34	1041	1.6%
1627.84	1035	1.6%
157.76	988	1.5%
1084.61	975	1.5%
181.44	893	1.4%
412.03	892	1.4%
Other values (1052)	54165	83.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	255	0.4%
0.3929	150	0.2%
0.4	21	< 0.1%
0.405	25	< 0.1%
0.41	10	< 0.1%
0.445	6	< 0.1%
0.52	1	< 0.1%
0.61	4	< 0.1%
1.6236	2	< 0.1%
1.8711	9	< 0.1%

Value	Count	Frequency (%)
2760.7	12	< 0.1%
2291.4	7	< 0.1%
2267	10	< 0.1%
1975	113	0.2%
1920	61	0.1%
1880	19	< 0.1%
1759.4	45	0.1%
1731.4	35	0.1%
1691.4	12	< 0.1%
1688.13	150	0.2%

Order Number
Real number (ℝ)

Distinct	17769
Distinct (%)	27.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	180567.61

Minimum	100838
Maximum	321532
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	509.8 KiB

Quantile statistics

Minimum	100838
5-th percentile	103465
Q1	115281
median	203695
Q3	218576
95-th percentile	319116
Maximum	321532
Range	220694
Interquartile range (IQR)	103295

Descriptive statistics

Standard deviation	67612.239
Coefficient of variation (CV)	0.37444278
Kurtosis	-0.63225366
Mean	180567.61
Median Absolute Deviation (MAD)	80306
Skewness	0.52670753
Sum	1.1780411 × 10¹⁰
Variance	4.5714148 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
210770	126	0.2%
222244	126	0.2%
110770	124	0.2%
122244	124	0.2%
205051	121	0.2%
105051	118	0.2%
320895	118	0.2%
212870	117	0.2%
220895	116	0.2%
120895	115	0.2%
Other values (17759)	64036	98.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100838	1	< 0.1%
100879	1	< 0.1%
100880	1	< 0.1%
100881	1	< 0.1%
100882	3	< 0.1%
100883	3	< 0.1%
100884	3	< 0.1%
100888	1	< 0.1%
100889	1	< 0.1%
100890	1	< 0.1%

Value	Count	Frequency (%)
321532	5	< 0.1%
321528	11	< 0.1%
321519	1	< 0.1%
321509	3	< 0.1%
321504	1	< 0.1%
321500	1	< 0.1%
321496	1	< 0.1%
321489	1	< 0.1%
321483	15	< 0.1%
321482	1	< 0.1%

Promised Delivery Date
Categorical

Distinct	590
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	509.8 KiB

27/06/2017	309
11/01/2017	305
09/07/2019	303
17/11/2017	273
29/11/2019	264
Other values (585)	63787

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	652410
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	22 ?
Unique (%)	< 0.1%

Sample

1st row	14/07/2017
2nd row	16/10/2017
3rd row	28/05/2017
4th row	03/09/2017
5th row	18/06/2017

Common Values

Value	Count	Frequency (%)
27/06/2017	309	0.5%
11/01/2017	305	0.5%
09/07/2019	303	0.5%
17/11/2017	273	0.4%
29/11/2019	264	0.4%
18/06/2017	248	0.4%
21/06/2017	238	0.4%
30/06/2019	235	0.4%
03/07/2019	231	0.4%
10/01/2017	231	0.4%
Other values (580)	62604	96.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
27/06/2017	309	0.5%
11/01/2017	305	0.5%
09/07/2019	303	0.5%
17/11/2017	273	0.4%
29/11/2019	264	0.4%
18/06/2017	248	0.4%
21/06/2017	238	0.4%
30/06/2019	235	0.4%
03/07/2019	231	0.4%
10/01/2017	231	0.4%
Other values (580)	62604	96.0%

Most occurring characters

Value	Count	Frequency (%)
0	144423	22.1%
/	130482	20.0%
1	122077	18.7%
2	105615	16.2%
7	41965	6.4%
9	40897	6.3%
8	18432	2.8%
3	16342	2.5%
6	11308	1.7%
5	11164	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	521928	80.0%
Other Punctuation	130482	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	144423	27.7%
1	122077	23.4%
2	105615	20.2%
7	41965	8.0%
9	40897	7.8%
8	18432	3.5%
3	16342	3.1%
6	11308	2.2%
5	11164	2.1%
4	9705	1.9%

Other Punctuation

Value	Count	Frequency (%)
/	130482	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	652410	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	144423	22.1%
/	130482	20.0%
1	122077	18.7%
2	105615	16.2%
7	41965	6.4%
9	40897	6.3%
8	18432	2.8%
3	16342	2.5%
6	11308	1.7%
5	11164	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	652410	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	144423	22.1%
/	130482	20.0%
1	122077	18.7%
2	105615	16.2%
7	41965	6.4%
9	40897	6.3%
8	18432	2.8%
3	16342	2.5%
6	11308	1.7%
5	11164	1.7%

Sales Amount
Real number (ℝ)

Distinct	17866
Distinct (%)	27.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2853.1211

Minimum	200.01
Maximum	555376
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	509.8 KiB

Quantile statistics

Minimum	200.01
5-th percentile	215.78
Q1	308.31
median	553.94
Q3	1279.75
95-th percentile	8795.9
Maximum	555376
Range	555175.99
Interquartile range (IQR)	971.44

Descriptive statistics

Standard deviation	15169.021
Coefficient of variation (CV)	5.3166412
Kurtosis	478.61708
Mean	2853.1211
Median Absolute Deviation (MAD)	292.92
Skewness	18.572946
Sum	1.8614047 × 10⁸
Variance	2.3009919 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
784.97	115	0.2%
817.68	115	0.2%
294.72	110	0.2%
307	104	0.2%
597.14	102	0.2%
622.02	101	0.2%
824.39	100	0.2%
791.41	99	0.2%
401.16	95	0.1%
204.66	92	0.1%
Other values (17856)	64208	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
200.01	6	< 0.1%
200.06	6	< 0.1%
200.08	1	< 0.1%
200.14	3	< 0.1%
200.15	5	< 0.1%
200.19	7	< 0.1%
200.21	1	< 0.1%
200.3	3	< 0.1%
200.36	1	< 0.1%
200.37	6	< 0.1%

Value	Count	Frequency (%)
555376	1	< 0.1%
539200	5	< 0.1%
517632	5	< 0.1%
472069.6	2	< 0.1%
458320	5	< 0.1%
439987.2	5	< 0.1%
310156.07	1	< 0.1%
301122.4	2	< 0.1%
297240	1	< 0.1%
289077.5	2	< 0.1%

Sales Amount Based on List Price
Real number (ℝ)

Distinct	4060
Distinct (%)	6.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4710.432

Minimum	0
Maximum	632610.16
Zeros	255
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	509.8 KiB

Quantile statistics

Minimum	0
5-th percentile	391.14
Q1	561.04
median	999.75
Q3	2321.4
95-th percentile	16425.12
Maximum	632610.16
Range	632610.16
Interquartile range (IQR)	1760.36

Descriptive statistics

Standard deviation	20702.61
Coefficient of variation (CV)	4.3950554
Kurtosis	278.54884
Mean	4710.432
Median Absolute Deviation (MAD)	526.47
Skewness	14.07067
Sum	3.0731329 × 10⁸
Variance	4.2859804 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1431.23	590	0.9%
1627.84	530	0.8%
803.86	498	0.8%
596	448	0.7%
1254.1899	418	0.6%
966.44	376	0.6%
439.7	372	0.6%
507.75	363	0.6%
767.75	348	0.5%
939.57	343	0.5%
Other values (4050)	60955	93.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	255	0.4%
194	2	< 0.1%
195.61	1	< 0.1%
198.396	1	< 0.1%
198.63	1	< 0.1%
200.7	8	< 0.1%
200.8	1	< 0.1%
201.69	3	< 0.1%
202.14	1	< 0.1%
202.6	1	< 0.1%

Value	Count	Frequency (%)
632610.16	5	< 0.1%
624453.75	2	< 0.1%
539200	11	< 0.1%
458320	12	< 0.1%
391924.7232	5	< 0.1%
387395	8	< 0.1%
348655.5	2	< 0.1%
332196.405	2	< 0.1%
330708.3792	5	< 0.1%
310273.7392	2	< 0.1%

Sales Cost Amount
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	5513
Distinct (%)	8.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1662.0231

Minimum	0
Maximum	366576
Zeros	308
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	509.8 KiB

Quantile statistics

Minimum	0
5-th percentile	85.36
Q1	167.81
median	304.58
Q3	688.55
95-th percentile	4946.11
Maximum	366576
Range	366576
Interquartile range (IQR)	520.74

Descriptive statistics

Standard deviation	9559.3969
Coefficient of variation (CV)	5.7516633
Kurtosis	613.9028
Mean	1662.0231
Median Absolute Deviation (MAD)	171.17
Skewness	21.004615
Sum	1.0843205 × 10⁸
Variance	91382069
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
449.69	534	0.8%
475.75	457	0.7%
0	308	0.5%
134.67	305	0.5%
162.89	289	0.4%
205.72	253	0.4%
159.14	242	0.4%
16718.08	234	0.4%
546.44	231	0.4%
344.28	229	0.4%
Other values (5503)	62159	95.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	308	0.5%
12.97	2	< 0.1%
19.55	4	< 0.1%
20.8	6	< 0.1%
26	1	< 0.1%
31.19	4	< 0.1%
33.97	3	< 0.1%
35.48	2	< 0.1%
35.54	5	< 0.1%
36.03	1	< 0.1%

Value	Count	Frequency (%)
366576	7	< 0.1%
353292.8	4	< 0.1%
311589.6	12	< 0.1%
185048.85	2	< 0.1%
161446.35	5	< 0.1%
157412.85	2	< 0.1%
153635.03	5	< 0.1%
146630.4	4	< 0.1%
141265.56	36	0.1%
137736.24	4	< 0.1%

Sales Margin Amount
Real number (ℝ)

Distinct	21266
Distinct (%)	32.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1191.098

Minimum	-3932.93
Maximum	188800
Zeros	3
Zeros (%)	< 0.1%
Negative	576
Negative (%)	0.9%
Memory size	509.8 KiB

Quantile statistics

Minimum	-3932.93
5-th percentile	61.54
Q1	129.89
median	246.48
Q3	578.22
95-th percentile	3825.85
Maximum	188800
Range	192732.93
Interquartile range (IQR)	448.33

Descriptive statistics

Standard deviation	5862.5666
Coefficient of variation (CV)	4.9219851
Kurtosis	324.74032
Mean	1191.098
Median Absolute Deviation (MAD)	140.23
Skewness	15.567055
Sum	77708425
Variance	34369688
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
374.7	93	0.1%
5317.17	88	0.1%
6235.31	87	0.1%
341.72	84	0.1%
15.32	69	0.1%
37.08	67	0.1%
52.8	67	0.1%
431.88	64	0.1%
464.59	64	0.1%
24.53	63	0.1%
Other values (21256)	64495	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3932.93	1	< 0.1%
-3764.4	2	< 0.1%
-3673.68	2	< 0.1%
-3608.81	1	< 0.1%
-3414.01	2	< 0.1%
-3132.65	2	< 0.1%
-2533.97	2	< 0.1%
-2508.21	2	< 0.1%
-2488.89	1	< 0.1%
-2103.04	2	< 0.1%

Value	Count	Frequency (%)
188800	1	< 0.1%
185907.2	2	< 0.1%
172624	3	< 0.1%
164339.2	2	< 0.1%
160480	2	< 0.1%
156773.4	1	< 0.1%
156521.04	1	< 0.1%
151056	3	< 0.1%
148401.6	3	< 0.1%
147487.37	2	< 0.1%

Sales Price
Real number (ℝ)

Distinct	14757
Distinct (%)	22.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	283.25028

Minimum	0.33734118
Maximum	6035
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	509.8 KiB

Quantile statistics

Minimum	0.33734118
5-th percentile	22.425556
Q1	100.03
median	183.28286
Q3	448.22
95-th percentile	787.12
Maximum	6035
Range	6034.6627
Interquartile range (IQR)	348.19

Descriptive statistics

Standard deviation	250.44861
Coefficient of variation (CV)	0.88419546
Kurtosis	5.8888259
Mean	283.25028
Median Absolute Deviation (MAD)	116.23352
Skewness	1.3311756
Sum	18479532
Variance	62724.509
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
140.43	191	0.3%
817.68	189	0.3%
133.41	181	0.3%
824.39	138	0.2%
783.17	138	0.2%
23.47	136	0.2%
82.87333333	125	0.2%
230.25	120	0.2%
221.04	120	0.2%
230.98	120	0.2%
Other values (14747)	63783	97.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.337341176	2	< 0.1%
0.3514	1	< 0.1%
0.361941176	1	< 0.1%
0.37718	67	0.1%
0.384	9	< 0.1%
0.3888	12	< 0.1%
0.3929	67	0.1%
0.3936	5	< 0.1%
0.4	9	< 0.1%
0.40469	16	< 0.1%

Value	Count	Frequency (%)
6035	1	< 0.1%
3748	1	< 0.1%
3009.86	1	< 0.1%
3003.41	1	< 0.1%
2823	1	< 0.1%
2753.32	1	< 0.1%
2540.17	1	< 0.1%
2360.1	1	< 0.1%
2314.39	1	< 0.1%
1989.61	1	< 0.1%

Sales Quantity
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	279
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45.106712

Minimum	1
Maximum	16000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	509.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	8
95-th percentile	86
Maximum	16000
Range	15999
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	429.79373
Coefficient of variation (CV)	9.5283764
Kurtosis	649.36123
Mean	45.106712
Median Absolute Deviation (MAD)	2
Skewness	23.000674
Sum	2942807
Variance	184722.65
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	15226	23.3%
2	13466	20.6%
3	7056	10.8%
4	4973	7.6%
5	3519	5.4%
6	3061	4.7%
10	2596	4.0%
8	1460	2.2%
12	1314	2.0%
20	1034	1.6%
Other values (269)	11536	17.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	15226	23.3%
2	13466	20.6%
3	7056	10.8%
4	4973	7.6%
5	3519	5.4%
6	3061	4.7%
7	711	1.1%
8	1460	2.2%
9	453	0.7%
10	2596	4.0%

Value	Count	Frequency (%)
16000	11	< 0.1%
13600	12	< 0.1%
9504	7	< 0.1%
8316	40	0.1%
7128	21	< 0.1%
7126	2	< 0.1%
6480	2	< 0.1%
6400	4	< 0.1%
5834	4	< 0.1%
4752	13	< 0.1%

Sales Rep
Real number (ℝ)

Distinct	64
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	137.42142

Minimum	103
Maximum	185
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	509.8 KiB

Quantile statistics

Minimum	103
5-th percentile	104
Q1	113
median	134
Q3	160
95-th percentile	180
Maximum	185
Range	82
Interquartile range (IQR)	47

Descriptive statistics

Standard deviation	26.644271
Coefficient of variation (CV)	0.19388732
Kurtosis	-1.3014508
Mean	137.42142
Median Absolute Deviation (MAD)	23
Skewness	0.35067578
Sum	8965511
Variance	709.91716
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
108	6225	9.5%
180	4426	6.8%
143	2926	4.5%
117	2440	3.7%
103	2162	3.3%
104	2065	3.2%
134	2032	3.1%
115	1986	3.0%
125	1967	3.0%
157	1743	2.7%
Other values (54)	37269	57.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
103	2162	3.3%
104	2065	3.2%
105	1184	1.8%
107	1303	2.0%
108	6225	9.5%
109	1137	1.7%
110	594	0.9%
111	542	0.8%
112	486	0.7%
113	1417	2.2%

Value	Count	Frequency (%)
185	537	0.8%
184	228	0.3%
183	326	0.5%
182	808	1.2%
181	792	1.2%
180	4426	6.8%
179	875	1.3%
176	1081	1.7%
175	1321	2.0%
173	794	1.2%

U/M
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	509.8 KiB

EA	58954
SE	5628
PR	659

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	130482
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EA
2nd row	EA
3rd row	SE
4th row	EA
5th row	EA

Common Values

Value	Count	Frequency (%)
EA	58954	90.4%
SE	5628	8.6%
PR	659	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ea	58954	90.4%
se	5628	8.6%
pr	659	1.0%

Most occurring characters

Value	Count	Frequency (%)
E	64582	49.5%
A	58954	45.2%
S	5628	4.3%
P	659	0.5%
R	659	0.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	130482	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	64582	49.5%
A	58954	45.2%
S	5628	4.3%
P	659	0.5%
R	659	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	130482	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	64582	49.5%
A	58954	45.2%
S	5628	4.3%
P	659	0.5%
R	659	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130482	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	64582	49.5%
A	58954	45.2%
S	5628	4.3%
P	659	0.5%
R	659	0.5%

Auto

Heatmap
Table

	Unnamed: 0	CustKey	Discount Amount	Invoice Number	Line Number	List Price	Order Number	Sales Amount	Sales Amount Based on List Price	Sales Cost Amount	Sales Margin Amount	Sales Price	Sales Quantity	Sales Rep	Item Class	U/M
Unnamed: 0	1.000	0.009	0.016	0.010	0.028	-0.007	0.279	0.017	0.017	0.014	0.027	-0.007	0.024	-0.001	0.009	0.026
CustKey	0.009	1.000	-0.016	-0.101	0.007	-0.008	0.081	0.015	0.006	0.019	0.011	-0.004	0.011	-0.161	0.012	0.053
Discount Amount	0.016	-0.016	1.000	0.078	0.001	0.437	-0.039	0.824	0.896	0.783	0.733	0.369	0.379	-0.045	0.000	0.000
Invoice Number	0.010	-0.101	0.078	1.000	0.012	0.014	-0.481	-0.002	0.031	0.023	-0.027	-0.019	0.012	0.007	0.000	0.016
Line Number	0.028	0.007	0.001	0.012	1.000	-0.042	0.015	-0.171	-0.113	-0.130	-0.202	-0.075	-0.053	-0.094	0.000	0.076
List Price	-0.007	-0.008	0.437	0.014	-0.042	1.000	0.003	0.356	0.381	0.388	0.287	0.980	-0.544	0.015	0.013	0.189
Order Number	0.279	0.081	-0.039	-0.481	0.015	0.003	1.000	0.000	-0.016	-0.027	0.037	0.020	-0.015	0.010	0.000	0.009
Sales Amount	0.017	0.015	0.824	-0.002	-0.171	0.356	0.000	1.000	0.968	0.932	0.890	0.358	0.484	0.011	0.000	0.009
Sales Amount Based on List Price	0.017	0.006	0.896	0.031	-0.113	0.381	-0.016	0.968	1.000	0.913	0.860	0.347	0.476	-0.010	0.000	0.012
Sales Cost Amount	0.014	0.019	0.783	0.023	-0.130	0.388	-0.027	0.932	0.913	1.000	0.708	0.375	0.422	0.001	0.000	0.011
Sales Margin Amount	0.027	0.011	0.733	-0.027	-0.202	0.287	0.037	0.890	0.860	0.708	1.000	0.300	0.475	0.021	0.000	0.012
Sales Price	-0.007	-0.004	0.369	-0.019	-0.075	0.980	0.020	0.358	0.347	0.375	0.300	1.000	-0.567	0.037	0.000	0.094
Sales Quantity	0.024	0.011	0.379	0.012	-0.053	-0.544	-0.015	0.484	0.476	0.422	0.475	-0.567	1.000	-0.032	0.000	0.007
Sales Rep	-0.001	-0.161	-0.045	0.007	-0.094	0.015	0.010	0.011	-0.010	0.001	0.021	0.037	-0.032	1.000	0.021	0.077
Item Class	0.009	0.012	0.000	0.000	0.000	0.013	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.021	1.000	0.000
U/M	0.026	0.053	0.000	0.016	0.076	0.189	0.009	0.009	0.012	0.011	0.012	0.094	0.007	0.077	0.000	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Unnamed: 0	CustKey	DateKey	Discount Amount	Invoice Date	Invoice Number	Item Class	Item Number	Item	Line Number	List Price	Order Number	Promised Delivery Date	Sales Amount	Sales Amount Based on List Price	Sales Margin Amount	Sales Price	Sales Quantity	Sales Rep	U/M
0	1	10002220	14/07/2017	368.7900	14/07/2017	100233	P01	20910	Moms Sliced Turkey	1000	824.9600	200245	14/07/2017	456.17	824.9600	456.17	456.170000	1	127	EA
1	2	10002220	17/10/2017	109.7300	17/10/2017	116165	P01	38076	Cutting Edge Foot-Long Hot Dogs	1000	548.6600	213157	16/10/2017	438.93	548.6600	438.93	438.930000	1	127	EA
2	4	10004516	27/05/2017	96627.9400	27/05/2017	103341	P01	60776	High Top Sweet Onion	1000	408.5200	203785	28/05/2017	89248.66	185876.6000	89248.66	196.150901	455	124	SE
3	6	10007866	03/09/2017	371.0140	03/09/2017	100403	P01	20910	Moms Sliced Turkey	2000	795.3140	200436	03/09/2017	424.30	795.3140	424.30	424.300000	1	149	EA
4	7	10009356	18/06/2017	608.0800	18/06/2017	105481	P01	62550	Tell Tale Garlic	29000	575.0000	205213	18/06/2017	541.92	1150.0000	541.92	270.960000	2	103	EA
5	8	10009356	18/06/2017	424.8000	18/06/2017	105481	P01	60794	High Top Walnuts	18000	51.8800	205213	18/06/2017	353.40	778.2000	353.40	23.560000	15	103	EA
6	9	10009356	18/06/2017	13492.8000	18/06/2017	105481	P01	36001	Big Time Frozen Cheese Pizza	9000	412.0300	205213	18/06/2017	11229.00	24721.8000	11229.00	187.150000	60	103	EA
7	10	10009356	18/06/2017	10481.1000	18/06/2017	105481	P01	38076	Cutting Edge Foot-Long Hot Dogs	13000	548.6600	205213	18/06/2017	8722.00	19203.1000	8722.00	249.200000	35	103	EA
8	11	10009356	18/06/2017	404.1465	18/06/2017	105481	P01	61484	Super Creamy Peanut Butter	37000	50.5051	205213	18/06/2017	353.43	757.5765	353.43	23.562000	15	103	EA
9	12	10009606	16/09/2017	1287.3476	16/09/2017	100445	P01	17801	Better Fancy Canned Sardines	3000	1379.7938	200478	16/09/2017	1472.24	2759.5876	1472.24	736.120000	2	118	EA

	Unnamed: 0	CustKey	DateKey	Discount Amount	Invoice Date	Invoice Number	Item Class	Item Number	Item	Line Number	List Price	Order Number	Promised Delivery Date	Sales Amount	Sales Amount Based on List Price	Sales Cost Amount	Sales Margin Amount	Sales Price	Sales Quantity	Sales Rep	U/M
65231	65272	10017638	21/03/2018	596.32	21/03/2018	226497	P01	30500	Blue Label Canned Beets	100000	634.11	320895	21/03/2018	671.90	1268.22	544.11	127.79	335.950000	2	180	EA
65232	65273	10017638	21/03/2018	4654.76	21/03/2018	226498	P01	20910	Moms Sliced Turkey	2000	824.96	320907	21/03/2018	5244.76	9899.52	3058.48	2186.28	437.063333	12	180	EA
65233	65274	10017638	21/03/2018	1582.78	21/03/2018	226497	P01	38060	Gorilla Strawberry Yogurt	153000	187.01	320895	21/03/2018	1783.40	3366.18	768.23	1015.17	99.077778	18	180	EA
65234	65275	10017638	21/03/2018	1095.70	21/03/2018	226497	P01	38007	Gorilla Jack Cheese	150000	1103.00	320895	21/03/2018	1110.30	2206.00	844.55	265.75	555.150000	2	180	EA
65235	65276	10017638	21/03/2018	277.61	21/03/2018	226497	P01	2040	Blue Label Fancy Canned Oysters	18000	14.76	320895	21/03/2018	312.79	590.40	268.40	44.39	7.819750	40	180	EA
65236	65277	10017638	21/03/2018	505.78	21/03/2018	226497	P01	13447	High Top Oranges	8000	119.52	320895	21/03/2018	569.90	1075.68	239.95	329.95	63.322222	9	180	EA
65237	65278	10017638	21/03/2018	410.75	21/03/2018	226497	P01	25906	Landslide White Sugar	38000	436.78	320895	21/03/2018	462.81	873.56	423.55	39.26	231.405000	2	180	EA
65238	65279	10017638	21/03/2018	876.16	21/03/2018	226497	P01	61856	Moms Potato Salad	227001	232.92	320895	21/03/2018	987.20	1863.36	574.00	413.20	123.400000	8	180	EA
65239	65280	10017638	21/03/2018	24226.77	21/03/2018	226498	P01	17801	Better Fancy Canned Sardines	1000	1431.23	320907	21/03/2018	27297.51	51524.28	16188.90	11108.61	758.264167	36	180	EA
65240	65281	10017638	21/03/2018	24479.26	21/03/2018	226498	P01	27550	Imagine Popsicles	4000	1084.61	320907	21/03/2018	27582.02	52061.28	14234.22	13347.80	574.625417	48	180	EA

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Lowercase Letter

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block